Aside

Download a PDF of this CV

Contact

Language / Software

R
SQL
Git
NA
Excel
Power BI
Tableau
QGIS

Disclaimer

Made with the R package pagedown

The source code is available on github.com/JulianCollins/cv

Last updated on 2020-06-02

Main

Julian Collins

I have a twenty year career as a data professional, working with official financial statistics and latterly healthcare data. Most recently I designed and developed a data warehouse of linked healthcare data for 250k patients.
My expertise lies in uncovering meaning in data - to drive forward quality improvements and to tell stories Currently looking for a position in healthcare analystics that allows me to exploit and develop my skills in R, data development, statistical analysis and visualisation.

Industry Experience

Data Manager

King’s Health Partners AHSN

London, UK

2019 - 2014

  • Designed and developed a data warehouse for diabetes care within the King’s Health Partners (AHSN) Institutue for Diabetes, Endocrinology and Obesity, linking patient-level data from more than twenty data sources, drawn from GSTT and KCH Foundation Trusts, Primary Care, Community Services and public sources. This pseudonymised data covered 250k people, with tens of millions of observations.
  • Using data pipeline SQL Server > R > Rmardkdown, produced a wide range of data and reports relating to the healthcare and outcomes of people with diabetes, including:
  • cohort studies investigating renal disease progression; ethnic variation in eye complications; diabetes outcomes in patients with prostate cancer
  • population studies highlighting variation in care and outcomes linked to deprivation/ethnicity/age, co-morbidities and service usage
  • audits into clinical services, medication reviews, NICE guidelines compliance
  • compiled National Diabetes Audit return for GSTT, enabling the trust to participate for the first time and successfully bringing together multiple sources to provide a detailed data picture that highlighted the excellent outcomes being delivered to Type 1 patients.
  • Collaborated with/presented to external, including international, partners of the AHSN (pharmaceutical and medical device companies, AI data consultants) highlighting the data warehouse outputs.

Data Analyst

GSTT NHS Foundation Trust

London, UK

2014 - 2012

  • The Diabetes Modernisation Initiative was a multi-year programme which brought together acute trusts, primary care, CCGs, community services and patient groups to improve health outcomes and services for people with diabetes in Lambeth and Southwark.
  • Worked with programme leads to design a range of dashboards that monitored monthly progress against projects goals and KPIs. Designed bespoke monthly programme storyboard that focussed on current priorities, highlighting areas for discussion, and items of particular success or concern.
  • A GP practice scorecard was used toward the end of the programme to drive continuous progress against patient outcome targets. Practices were aware of their overall position in comparison to peers and were also supplied with unique targets modelled against specific patient lists. This approach was extremely successful in both achieving GP buy-in and improving patient outcomes.

Sector Statistician

Office for National Statistics

London, UK

2010 - 2009

  • Led a team of analysts compiling and publishing statistics relating to corporate activity on a quarterly and annual basis. Main outputs were sectoral data for quarterly/annual GDP and quarterly profitability publication.
  • In addition to technical tasks relating to data compilation and consistency checking, this role required a range of research and analytical work to be conducted in order to understand trends at sector, sub-sector and business levels. Research activities would include working with the Business Survey teams to understand sampling frames and company response rates; confronting survey data with a range of other sources; analysing published corporate accounts; monitoring trade press.
  • Explained data movements to a range of users, including national financial journalists (e.g. FT, BBC, Guardian) and discussing with expert customers such as Bank of England Monetary Policy Committee members.

Publications Manager

Office for National Statistics

London, UK

2008 - 2007

  • Led a team compiling regional and local breakdowns of GVA and Household Income. These data were used to calculate UK structural funds allocations from the EU

Statistical Analyst

Office for National Statistics

London, UK

2007 - 2001

  • Data compilation and analysis for UK Balance of Payments
  • I represented the UK and a joint EU/ECB task force investigating data coherence and consistency across data frameworks and member states.

Education

MA Hons Geography 2:1

University of St.Andrews

Fife, UK

1998 - 1994

  • sub-honours studies in psychology, social anthropology and mediaeval history


Other Data Science

TidyTuesday’ data visualisation challenge

https://nsgrantham.shinyapps.io/tidytuesdayrocks/

N/A

2020 - 2019

  • Twitter community participating in weekly data visualisation challenge.

Authored internal-use R package ‘rIDEO’

https://github.com/KHP-IDEO/rIDEO

N/A

2019 - 2018

  • Suite of functions to parse and categorise various data for people with diabetes

Selected Publications and Posters

Screening for co-existing thyroid and coeliac disease in type 1 diabetes. An audit of practice against updated NICE guidelines.

Abstract

N/A

2019

  • co-author